/*
 Navicat Premium Data Transfer

 Source Server         : 蜗牛工作室-本地测试
 Source Server Type    : MySQL
 Source Server Version : 50735
 Source Host           : 127.0.0.1:3306
 Source Schema         : localdb_pesdev_v1023

 Target Server Type    : MySQL
 Target Server Version : 50735
 File Encoding         : 65001

 Date: 03/11/2021 17:56:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for pes_attachment
-- ----------------------------
DROP TABLE IF EXISTS `pes_attachment`;
CREATE TABLE `pes_attachment` (
  `attachment_id` int(11) NOT NULL AUTO_INCREMENT,
  `attachment_createtime` int(11) NOT NULL DEFAULT '0',
  `attachment_name` varchar(255) NOT NULL DEFAULT '',
  `attachment_path` varchar(255) NOT NULL DEFAULT '',
  `attachment_type` int(11) NOT NULL DEFAULT '0',
  `attachment_upload_name` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`attachment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for pes_bulletin
-- ----------------------------
DROP TABLE IF EXISTS `pes_bulletin`;
CREATE TABLE `pes_bulletin` (
  `bulletin_id` int(11) NOT NULL AUTO_INCREMENT,
  `bulletin_listsort` int(11) NOT NULL DEFAULT '0',
  `bulletin_createtime` int(11) NOT NULL DEFAULT '0',
  `bulletin_title` varchar(255) NOT NULL DEFAULT '',
  `bulletin_content` text NOT NULL,
  PRIMARY KEY (`bulletin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pes_bulletin
-- ----------------------------
BEGIN;
INSERT INTO `pes_bulletin` VALUES (1, 0, 1454126400, 'Hello World', '欢迎使用PESCMS TEAM');
INSERT INTO `pes_bulletin` VALUES (2, 0, 1635931680, '2', '&lt;p&gt;22&lt;/p&gt;');
INSERT INTO `pes_bulletin` VALUES (3, 0, 1635932400, 's', '&lt;p&gt;ssss&lt;/p&gt;');
COMMIT;

-- ----------------------------
-- Table structure for pes_department
-- ----------------------------
DROP TABLE IF EXISTS `pes_department`;
CREATE TABLE `pes_department` (
  `department_id` int(11) NOT NULL AUTO_INCREMENT,
  `department_listsort` int(11) NOT NULL DEFAULT '0',
  `department_name` varchar(255) NOT NULL DEFAULT '',
  `department_header` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`department_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='部门列表';

-- ----------------------------
-- Records of pes_department
-- ----------------------------
BEGIN;
INSERT INTO `pes_department` VALUES (1, 1, '蜗牛工作室', '1');
COMMIT;

-- ----------------------------
-- Table structure for pes_dynamic
-- ----------------------------
DROP TABLE IF EXISTS `pes_dynamic`;
CREATE TABLE `pes_dynamic` (
  `dynamic_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '谁触发的动态',
  `task_id` int(11) NOT NULL DEFAULT '0' COMMENT '任务',
  `dynamic_time` int(11) NOT NULL DEFAULT '0' COMMENT '时间',
  PRIMARY KEY (`dynamic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户动态';

-- ----------------------------
-- Table structure for pes_field
-- ----------------------------
DROP TABLE IF EXISTS `pes_field`;
CREATE TABLE `pes_field` (
  `field_id` int(11) NOT NULL AUTO_INCREMENT,
  `field_model_id` int(11) NOT NULL DEFAULT '0',
  `field_name` varchar(128) NOT NULL DEFAULT '',
  `field_display_name` varchar(128) NOT NULL DEFAULT '',
  `field_type` varchar(128) NOT NULL DEFAULT '',
  `field_option` text NOT NULL,
  `field_explain` varchar(255) NOT NULL DEFAULT '',
  `field_default` varchar(128) NOT NULL DEFAULT '',
  `field_required` tinyint(4) NOT NULL DEFAULT '0',
  `field_listsort` int(11) NOT NULL DEFAULT '0',
  `field_list` tinyint(1) NOT NULL DEFAULT '0',
  `field_form` tinyint(1) NOT NULL DEFAULT '0',
  `field_status` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`field_id`),
  UNIQUE KEY `modle_id` (`field_model_id`,`field_name`)
) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=utf8 COMMENT='字段列表';

-- ----------------------------
-- Records of pes_field
-- ----------------------------
BEGIN;
INSERT INTO `pes_field` VALUES (12, 8, 'listsort', '排序', 'text', '', '', '', 0, 98, 1, 1, 1);
INSERT INTO `pes_field` VALUES (14, 8, 'title', '项目名称', 'text', '', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (15, 9, 'status', '状态', 'text', '', '', '', 0, 97, 0, 1, 0);
INSERT INTO `pes_field` VALUES (19, 9, 'title', '任务标题', 'text', '', '', '', 1, 2, 0, 1, 1);
INSERT INTO `pes_field` VALUES (22, 9, 'create_id', '任务发起者', 'text', '', '', '', 1, 99, 0, 0, 1);
INSERT INTO `pes_field` VALUES (24, 9, 'content', '任务说明', 'editor', '', '', '', 0, 6, 0, 1, 1);
INSERT INTO `pes_field` VALUES (30, 10, 'listsort', '排序', 'text', '', '', '', 1, 98, 1, 1, 1);
INSERT INTO `pes_field` VALUES (32, 10, 'name', '部门名称', 'text', '', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (33, 10, 'header', '负责人', 'text', '', '', '', 0, 2, 1, 1, 1);
INSERT INTO `pes_field` VALUES (35, 9, 'priority', '优先级', 'select', '{\"\\u8bf7\\u9009\\u62e9\":\"\",\"P1\\u91cd\\u8981\\u4e14\\u7d27\\u6025\":1,\"P2\\u91cd\\u8981\\u4e14\\u4e0d\\u7d27\\u6025\":2,\"P3\\u4e0d\\u91cd\\u8981\\u4e14\\u7d27\\u6025\":4,\"P4\\u4e0d\\u91cd\\u8981\\u4e14\\u4e0d\\u7d27\\u6025\":5}', '', '', 1, 3, 0, 1, 1);
INSERT INTO `pes_field` VALUES (37, 9, 'project_id', '任务项目', 'select', '{\"\\u8bf7\\u9009\\u62e9\":\"\",\"\\u5de5\\u4f5c\\u5ba4\\u7b2c\\u56db\\u5b63\\u5ea6\\u4efb\\u52a1\\u5b89\\u6392\":3,\"\\u5764\\u65f6\\u672c\\u5468\\u5de5\\u4f5c\\u5b89\\u6392\":2,\"\\u4e0d\\u6307\\u5b9a\\u4efb\\u52a1\":1}', '', '', 1, 1, 0, 1, 1);
INSERT INTO `pes_field` VALUES (38, 9, 'read_permission', '阅读权限', 'radio', '{&quot;\\u5173\\u95ed&quot;:&quot;0&quot;,&quot;\\u5f00\\u542f&quot;:&quot;1&quot;}', '', '0', 1, 9, 0, 1, 1);
INSERT INTO `pes_field` VALUES (46, 9, 'mail', '是否发送邮件', 'radio', '{\"\\u5426\":\"0\",\"\\u662f\":\"1\"}', '', '0', 1, 96, 0, 1, 1);
INSERT INTO `pes_field` VALUES (57, 1, 'name', '模型名称', 'text', '', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (58, 1, 'title', '显示名称', 'text', '', '', '', 1, 2, 1, 1, 1);
INSERT INTO `pes_field` VALUES (59, 1, 'search', '允许搜索', 'radio', '{\"\\u5173\\u95ed\":\"0\",\"\\u5f00\\u542f\":\"1\"}', '', '', 1, 3, 1, 1, 1);
INSERT INTO `pes_field` VALUES (60, 1, 'attr', '模型属性', 'radio', '{\"\\u524d\\u53f0\":\"1\",\"\\u540e\\u53f0\":\"2\"}', '', '', 1, 4, 1, 1, 1);
INSERT INTO `pes_field` VALUES (61, 1, 'status', '模型状态', 'radio', '{\"\\u542f\\u7528\":\"1\",\"\\u7981\\u7528\":\"0\"}', '', '', 1, 5, 1, 1, 1);
INSERT INTO `pes_field` VALUES (62, 2, 'model_id', '模型ID', 'text', '', '', '', 1, 0, 0, 0, 1);
INSERT INTO `pes_field` VALUES (63, 2, 'type', '字段类型', 'select', '{\"\\u5206\\u7c7b\":\"category\",\"\\u5355\\u884c\\u8f93\\u5165\\u6846\":\"text\",\"\\u5355\\u9009\\u6309\\u94ae\":\"radio\",\"\\u590d\\u9009\\u6846\":\"checkbox\",\"\\u5355\\u9009\\u4e0b\\u62c9\\u6846\":\"select\",\"\\u591a\\u884c\\u8f93\\u5165\\u6846\":\"textarea\",\"\\u7f16\\u8f91\\u5668\":\"editor\",\"\\u7565\\u7f29\\u56fe\":\"thumb\",\"\\u4e0a\\u4f20\\u56fe\\u7ec4\":\"img\",\"\\u4e0a\\u4f20\\u6587\\u4ef6\":\"file\",\"\\u65e5\\u671f\":\"date\",\"\\u989c\\u8272\":\"color\",\"\\u56fe\\u6807\":\"icon\"}', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (64, 2, 'name', '字段名称', 'text', '', '', '', 1, 2, 1, 1, 1);
INSERT INTO `pes_field` VALUES (65, 2, 'display_name', '显示名称', 'text', '', '', '', 1, 3, 1, 1, 1);
INSERT INTO `pes_field` VALUES (66, 2, 'option', '选项值', 'textarea', '', '选填， 选填， 此处若没有特殊说明，必须 名称|值 填写、且一行一个选项值，否则将导致数据异常!  注意:目前选项适用于单选，复选，下拉菜单。其余功能填写也不会产生任何实际效果。', '', 0, 4, 0, 1, 1);
INSERT INTO `pes_field` VALUES (67, 2, 'explain', '字段说明', 'textarea', '', '', '', 0, 5, 0, 1, 1);
INSERT INTO `pes_field` VALUES (68, 2, 'default', '默认值', 'text', '', '', '', 0, 6, 0, 1, 1);
INSERT INTO `pes_field` VALUES (69, 2, 'required', '是否必填', 'radio', '{\"\\u662f\":\"1\",\"\\u5426\":\"0\"}', '', '', 1, 7, 1, 1, 1);
INSERT INTO `pes_field` VALUES (70, 2, 'list', '显示列表', 'radio', '{\"\\u663e\\u793a\":\"1\",\"\\u9690\\u85cf\":\"0\"}', '', '', 1, 8, 1, 1, 1);
INSERT INTO `pes_field` VALUES (71, 2, 'form', '显示表单', 'radio', '{\"\\u663e\\u793a\":\"1\",\"\\u9690\\u85cf\":\"0\"}', '', '', 1, 9, 1, 1, 1);
INSERT INTO `pes_field` VALUES (72, 2, 'status', '字段状态', 'radio', '{\"\\u542f\\u7528\":\"1\",\"\\u7981\\u7528\":\"0\"}', '', '', 1, 11, 1, 1, 1);
INSERT INTO `pes_field` VALUES (73, 2, 'listsort', '排序', 'text', '', '', '', 0, 99, 0, 1, 1);
INSERT INTO `pes_field` VALUES (74, 3, 'name', '菜单名称', 'text', '', '', '', 0, 2, 1, 1, 1);
INSERT INTO `pes_field` VALUES (75, 3, 'pid', '菜单层级', 'select', '', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (76, 3, 'icon', '菜单图标', 'text', '', '', '', 1, 5, 1, 1, 1);
INSERT INTO `pes_field` VALUES (77, 3, 'link', '菜单地址', 'text', '{&quot;\\u82e5\\u9009\\u62e9\\u7ad9\\u5185\\u94fe\\u63a5\\uff0c\\u8bf7\\u4ee5\\u7ec4-\\u63a7\\u5236\\u5668-\\u65b9\\u6cd5\\u5f62\\u5f0f\\u586b\\u5199\\u3002&quot;:&quot;&quot;}', '', '', 0, 4, 1, 1, 1);
INSERT INTO `pes_field` VALUES (78, 3, 'listsort', '排序', 'text', '', '', '', 0, 6, 1, 1, 1);
INSERT INTO `pes_field` VALUES (79, 6, 'status', '状态', 'radio', '{\"\\u7981\\u7528\":\"0\",\"\\u542f\\u7528\":\"1\"}', '', '1', 1, 100, 1, 1, 1);
INSERT INTO `pes_field` VALUES (80, 6, 'createtime', '发布时间', 'date', '', '', '', 0, 99, 0, 0, 0);
INSERT INTO `pes_field` VALUES (81, 7, 'status', '状态', 'radio', '{\"\\u7981\\u7528\":\"0\",\"\\u542f\\u7528\":\"1\"}', '', '1', 1, 100, 1, 1, 1);
INSERT INTO `pes_field` VALUES (82, 7, 'account', '会员帐号', 'text', '', '', '', 1, 3, 1, 1, 1);
INSERT INTO `pes_field` VALUES (83, 7, 'password', '会员密码', 'text', '', '新增用户时,密码为必填.编辑用户时为空则表示不修改密码', '', 0, 4, 0, 1, 1);
INSERT INTO `pes_field` VALUES (84, 7, 'mail', '邮箱地址', 'text', '', '', '', 1, 5, 1, 1, 1);
INSERT INTO `pes_field` VALUES (85, 7, 'name', '会员名称', 'text', '', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (86, 7, 'group_id', '用户组', 'select', '{\"\\u7ba1\\u7406\\u5458\":1,\"\\u666e\\u901a\\u4f1a\\u5458\":2,\"\\u90e8\\u95e8\\u8d23\\u4efb\\u4eba\":3}', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (87, 6, 'name', '用户组名称', 'text', '', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (88, 13, 'name', '节点名称', 'text', '', '', '', 1, 3, 0, 1, 1);
INSERT INTO `pes_field` VALUES (89, 13, 'parent', '所属菜单', 'select', '{\"\\u8bf7\\u9009\\u62e9\":\"\",\"\\u9876\\u5c42\\u83dc\\u5355\":\"0\",\"\\u65b0\\u4efb\\u52a1\":1,\"\\u4e2a\\u4eba\\u4e2d\\u5fc3\":2,\"\\u7528\\u6237\\u4e2d\\u5fc3\":3,\"\\u5185\\u5bb9\\u7ba1\\u7406\":4,\"\\u9ad8\\u7ea7\\u8bbe\\u7f6e\":5,\"\\u9690\\u85cf\\u64cd\\u4f5c\":90,\"\\u63a7\\u5236\\u5668\\u5c42\":6}', '本选项仅用于布置当前权限节点显示于何方。', '', 1, 1, 0, 1, 1);
INSERT INTO `pes_field` VALUES (90, 13, 'verify', '是否验证', 'radio', '{&quot;\\u4e0d\\u9a8c\\u8bc1&quot;:&quot;0&quot;,&quot;\\u9a8c\\u8bc1&quot;:&quot;1&quot;}', '', '', 0, 4, 0, 1, 1);
INSERT INTO `pes_field` VALUES (91, 13, 'msg', '提示信息', 'text', '', '', '', 0, 5, 0, 1, 1);
INSERT INTO `pes_field` VALUES (92, 13, 'method_type', '请求方法', 'select', '{&quot;GET&quot;:&quot;GET&quot;,&quot;POST&quot;:&quot;POST&quot;,&quot;PUT&quot;:&quot;PUT&quot;,&quot;DELETE&quot;:&quot;DELETE&quot;}', '', '', 0, 6, 0, 1, 1);
INSERT INTO `pes_field` VALUES (93, 13, 'value', '节点匹配值', 'text', '', '若选择父类节点为控制器，请填写控制器名称。反之填写方法名。区分大小写', '', 0, 7, 0, 1, 1);
INSERT INTO `pes_field` VALUES (94, 13, 'check_value', '验证值', 'text', '', '', '', 0, 8, 0, 0, 1);
INSERT INTO `pes_field` VALUES (95, 4, 'controller', '路由控制器', 'text', '', '控制器填写以‘-’为分隔符，分别以：组-控制器名称-方法 形式填写。若是默认组的控制器，那么可以忽略填写组参数。', '', 1, 2, 1, 1, 1);
INSERT INTO `pes_field` VALUES (96, 4, 'param', '显式参数', 'text', '', '若URL存在GET参数，填写上该参数，以半角逗号隔开。如有三个参数a，b，c。那么填写为：a,b,c', '', 0, 3, 1, 1, 1);
INSERT INTO `pes_field` VALUES (97, 4, 'rule', '路由规则', 'text', '', '若链接中存在显式参数，那么用左右大括号包围着。如参数number，那么路由规则这样写：route/{number}。同时规则开头不要添加任何字符，且分隔符只能为\'/\'', '', 1, 4, 1, 1, 1);
INSERT INTO `pes_field` VALUES (98, 4, 'title', '路由名称', 'text', '', '建议填写，以免路由规则过多时，自己也不清楚谁是他的爹。', '', 0, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (99, 4, 'hash', '路由哈希值', 'text', '', '', '', 1, 99, 0, 0, 1);
INSERT INTO `pes_field` VALUES (100, 4, 'listsort', '排序', 'text', '', '', '', 0, 100, 1, 1, 1);
INSERT INTO `pes_field` VALUES (101, 4, 'status', '启用状态', 'radio', '{&quot;\\u542f\\u7528&quot;:&quot;1&quot;,&quot;\\u7981\\u7528&quot;:&quot;0&quot;}', '', '', 1, 7, 1, 1, 1);
INSERT INTO `pes_field` VALUES (102, 13, 'controller', '父类节点', 'select', '{\"\\u8bf7\\u9009\\u62e9\":\"\",\"\\u9876\\u5c42\\u8282\\u70b9\":\"0\",\"\\u975e\\u6743\\u9650\\u8282\\u70b9\":\"-1\",\"\\u4efb\\u52a1\\u6a21\\u578b\":7,\"\\u7528\\u6237\\u6a21\\u578b\":8,\"\\u7528\\u6237\\u7ec4\\u6a21\\u578b\":9,\"\\u90e8\\u95e8\\u6a21\\u578b\":10,\"\\u8282\\u70b9\\u6a21\\u578b\":11,\"\\u516c\\u544a\\u6a21\\u578b\":12,\"\\u4efb\\u52a1\\u72b6\\u6001\\u6a21\\u578b\":13,\"\\u9644\\u4ef6\\u6a21\\u578b\":14,\"\\u63d0\\u53d6\\u62a5\\u8868\\u6a21\\u578b\":15,\"\\u9879\\u76ee\\u6a21\\u578b\":16,\"\\u7cfb\\u7edf\\u8bbe\\u7f6e\\u6a21\\u578b\":17,\"\\u83dc\\u5355\\u7ba1\\u7406\\u6a21\\u578b\":18,\"\\u8def\\u7531\\u89c4\\u5219\\u6a21\\u578b\":19,\"\\u6a21\\u578b\\u7ba1\\u7406\":20,\"\\u5b57\\u6bb5\\u6a21\\u578b\":21,\"\\u4efb\\u52a1\\u4f18\\u5148\\u5ea6\\u6a21\\u578b\":101}', '', '', 1, 2, 1, 1, 1);
INSERT INTO `pes_field` VALUES (103, 13, 'listsort', '排序', 'text', '', '', '', 0, 99, 1, 1, 1);
INSERT INTO `pes_field` VALUES (104, 3, 'type', '链接类型', 'radio', '{&quot;\\u7ad9\\u5185\\u94fe\\u63a5&quot;:&quot;0&quot;,&quot;\\u7ad9\\u5916\\u8fde\\u63a5&quot;:&quot;1&quot;}', '', '', 1, 3, 1, 1, 1);
INSERT INTO `pes_field` VALUES (105, 7, 'department_id', '所属部门', 'select', '{\"\\u8bf7\\u9009\\u62e9\":\"\",\"\\u8717\\u725b\\u5de5\\u4f5c\\u5ba4\":1}', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (106, 9, 'start_time', '开始时间', 'date', '', '', '', 1, 4, 0, 0, 1);
INSERT INTO `pes_field` VALUES (107, 9, 'end_time', '结束时间', 'date', '', '', '', 1, 4, 0, 0, 1);
INSERT INTO `pes_field` VALUES (108, 9, 'submit_time', '任务提交时间', 'date', '', '', '', 0, 4, 0, 0, 1);
INSERT INTO `pes_field` VALUES (109, 9, 'multiplayer', '多人指派', 'text', '', '', '', 0, 99, 0, 0, 1);
INSERT INTO `pes_field` VALUES (112, 14, 'createtime', '创建时间', 'date', '', '', '', 0, 99, 0, 0, 1);
INSERT INTO `pes_field` VALUES (113, 14, 'name', '附件名称', 'text', '', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (114, 14, 'path', '附件所在路径', 'text', '', '', '', 1, 3, 0, 1, 1);
INSERT INTO `pes_field` VALUES (115, 14, 'type', '附件类型', 'radio', '{&quot;\\u56fe\\u7247&quot;:&quot;1&quot;,&quot;\\u6587\\u4ef6&quot;:&quot;2&quot;}', '', '', 1, 4, 1, 1, 1);
INSERT INTO `pes_field` VALUES (116, 14, 'upload_name', '上传名称', 'text', '', '', '', 1, 2, 1, 1, 1);
INSERT INTO `pes_field` VALUES (119, 15, 'createtime', '创建时间', 'date', '', '', '', 0, 99, 0, 0, 1);
INSERT INTO `pes_field` VALUES (120, 15, 'task_id', '所属任务', 'text', '', '', '', 1, 1, 0, 0, 1);
INSERT INTO `pes_field` VALUES (121, 15, 'user_id', '所属用户', 'text', '', '', '', 1, 2, 0, 0, 1);
INSERT INTO `pes_field` VALUES (122, 15, 'content', '动态内容', 'text', '', '', '', 1, 3, 0, 0, 1);
INSERT INTO `pes_field` VALUES (123, 17, 'content', '补充内容', 'editor', '', '', '', 1, 6, 0, 1, 1);
INSERT INTO `pes_field` VALUES (124, 17, 'createtime', '补充时间', 'date', '', '', '', 0, 6, 0, 0, 1);
INSERT INTO `pes_field` VALUES (125, 17, 'task_id', '任务ID', 'text', '', '', '', 1, 6, 0, 0, 1);
INSERT INTO `pes_field` VALUES (126, 17, 'user_id', '发起者', 'text', '', '', '', 1, 6, 0, 0, 1);
INSERT INTO `pes_field` VALUES (130, 18, 'name', '状态名称', 'text', '', '', '', 1, 2, 1, 1, 1);
INSERT INTO `pes_field` VALUES (131, 18, 'icon', '状态图标', 'icon', '', '', '', 1, 3, 1, 1, 1);
INSERT INTO `pes_field` VALUES (132, 18, 'color', '状态颜色', 'color', '', '', '', 1, 4, 1, 1, 1);
INSERT INTO `pes_field` VALUES (133, 18, 'type', '状态类型', 'select', '{&quot;\\u672a\\u6267\\u884c\\u7684\\u4efb\\u52a1&quot;:&quot;0&quot;,&quot;\\u6267\\u884c\\u4e2d\\u7684\\u4efb\\u52a1&quot;:&quot;1&quot;,&quot;\\u5ba1\\u6838\\u4e2d\\u7684\\u4efb\\u52a1&quot;:&quot;2&quot;,&quot;\\u5b8c\\u6210\\u7684\\u4efb\\u52a1&quot;:&quot;3&quot;,&quot;\\u5173\\u95ed\\u7684\\u4efb\\u52a1&quot;:&quot;10&quot;}', '自定义设置状态信息，请依据本选项选择类型。', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (134, 8, 'content', '项目描述', 'editor', '', '', '', 0, 2, 0, 1, 1);
INSERT INTO `pes_field` VALUES (135, 7, 'phone', '联系电话', 'text', '', '', '', 0, 6, 1, 1, 1);
INSERT INTO `pes_field` VALUES (137, 20, 'listsort', '排序', 'text', '', '', '', 0, 98, 1, 1, 1);
INSERT INTO `pes_field` VALUES (138, 20, 'createtime', '创建时间', 'date', '', '', '', 1, 99, 1, 1, 1);
INSERT INTO `pes_field` VALUES (139, 20, 'title', '标题', 'text', '', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (140, 20, 'content', '内容', 'editor', '', '', '', 0, 2, 0, 1, 1);
INSERT INTO `pes_field` VALUES (144, 21, 'listsort', '排序', 'text', '', '', '', 0, 99, 1, 1, 1);
INSERT INTO `pes_field` VALUES (145, 21, 'name', '优先度名称', 'text', '', '', '', 1, 1, 1, 1, 1);
INSERT INTO `pes_field` VALUES (146, 21, 'color', '标记颜色', 'color', '', '', '', 1, 2, 1, 1, 1);
INSERT INTO `pes_field` VALUES (147, 9, 'repeat', '任务重复天数', 'text', '', '1.重复天数大于0才会触发重复属性。\r\n2.任务重复将在任务状态为完成或关闭时触发。\r\n3.系统发布的重复任务结束时间将以任务生成时间+重复天数为截止。\r\n4.输入1即表示重复任务的完成周期在1天，如此类推。', '', 0, 7, 0, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for pes_findpassword
-- ----------------------------
DROP TABLE IF EXISTS `pes_findpassword`;
CREATE TABLE `pes_findpassword` (
  `findpassword_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
  `findpassword_mark` varchar(255) NOT NULL DEFAULT '' COMMENT '标记',
  `findpassword_createtime` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`findpassword_id`),
  UNIQUE KEY `findpassword_mark` (`findpassword_mark`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='查找密码';

-- ----------------------------
-- Table structure for pes_menu
-- ----------------------------
DROP TABLE IF EXISTS `pes_menu`;
CREATE TABLE `pes_menu` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(128) NOT NULL DEFAULT '',
  `menu_pid` int(11) NOT NULL DEFAULT '0',
  `menu_icon` varchar(128) NOT NULL DEFAULT '',
  `menu_link` varchar(255) NOT NULL DEFAULT '',
  `menu_listsort` tinyint(100) NOT NULL DEFAULT '0',
  `menu_type` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`menu_id`),
  KEY `menu_pid` (`menu_pid`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COMMENT='菜单列表';

-- ----------------------------
-- Records of pes_menu
-- ----------------------------
BEGIN;
INSERT INTO `pes_menu` VALUES (8, '后台菜单', 19, 'am-icon-align-justify', 'Team-Menu-index', 5, 0);
INSERT INTO `pes_menu` VALUES (9, '内容管理', 0, 'am-icon-database', '', 4, 0);
INSERT INTO `pes_menu` VALUES (16, '会员列表', 55, 'am-icon-user', 'Team-User-index', 1, 0);
INSERT INTO `pes_menu` VALUES (18, '用户组', 55, 'am-icon-group', 'Team-User_group-index', 2, 0);
INSERT INTO `pes_menu` VALUES (19, '高级设置', 0, 'am-icon-wrench', '', 5, 0);
INSERT INTO `pes_menu` VALUES (20, '系统设置', 19, 'am-icon-server', 'Team-Setting-action', 9, 0);
INSERT INTO `pes_menu` VALUES (38, '项目列表', 13, 'am-icon-cubes', 'Team-Project-index', 0, 0);
INSERT INTO `pes_menu` VALUES (39, '任务列表', 41, 'am-icon-tasks', 'Team-Task-index', 40, 0);
INSERT INTO `pes_menu` VALUES (40, '部门列表', 55, 'am-icon-legal', 'Team-Department-index', 3, 0);
INSERT INTO `pes_menu` VALUES (41, '个人中心', 0, 'am-icon-home', '', 2, 0);
INSERT INTO `pes_menu` VALUES (42, '我的任务', 41, 'am-icon-tags', 'Team-Task-my', 20, 0);
INSERT INTO `pes_menu` VALUES (46, '我的报表', 41, 'am-icon-pencil-square-o', 'Team-Report-my', 50, 0);
INSERT INTO `pes_menu` VALUES (48, '提取报表', 9, 'am-icon-newspaper-o', 'Team-Report-extract', 4, 0);
INSERT INTO `pes_menu` VALUES (49, '权限节点', 55, 'am-icon-unlink', 'Team-Node-index', 4, 0);
INSERT INTO `pes_menu` VALUES (50, '提取全体报表', 9, 'am-icon-newspaper-o', 'Team-Report-allExtract', 3, 0);
INSERT INTO `pes_menu` VALUES (51, '新任务', 0, 'am-icon-plus', 'Team-Task-action', 1, 0);
INSERT INTO `pes_menu` VALUES (54, '项目列表', 19, 'am-icon-cubes', 'Team-Project-index', 6, 0);
INSERT INTO `pes_menu` VALUES (55, '用户中心', 0, 'am-icon-street-view', '', 3, 0);
INSERT INTO `pes_menu` VALUES (56, '附件管理', 19, 'am-icon-arrow-circle-down', 'Team-Attachment-index', 3, 0);
INSERT INTO `pes_menu` VALUES (58, '任务状态', 9, 'am-icon-anchor', 'Team-Task_status-index', 1, 0);
INSERT INTO `pes_menu` VALUES (59, '任务看板', 41, 'am-icon-book', 'Team-Task-myCard', 30, 0);
INSERT INTO `pes_menu` VALUES (60, '审核列表', 41, 'am-icon-check-square', 'Team-Task-check', 60, 0);
INSERT INTO `pes_menu` VALUES (61, '部门指派', 41, 'am-icon-deviantart', 'Team-Task-department', 70, 0);
INSERT INTO `pes_menu` VALUES (62, '账号设置', 41, 'am-icon-drupal', 'Team-User-setting', 99, 0);
INSERT INTO `pes_menu` VALUES (63, '公告栏', 9, 'am-icon-building', 'Team-Bulletin-index', 0, 0);
INSERT INTO `pes_menu` VALUES (64, '退出登录', 41, 'am-icon-sign-out', 'Team-Index-logout', 127, 0);
INSERT INTO `pes_menu` VALUES (65, '任务优先度', 9, 'am-icon-sort-alpha-asc', 'Team-Priority-index', 2, 0);
INSERT INTO `pes_menu` VALUES (66, '仪表盘', 41, 'am-icon-tachometer', 'Team-Index-index', 10, 0);
INSERT INTO `pes_menu` VALUES (67, '任务重复管理', 41, 'am-icon-repeat', 'Team-Task-repeat', 71, 0);
INSERT INTO `pes_menu` VALUES (68, '软件协议', 19, 'am-icon-paste', 'https://www.pescms.com/Page/Authorization.html', 98, 1);
INSERT INTO `pes_menu` VALUES (69, '帮助文档', 19, 'am-icon-header', 'https://www.pescms.com/d/index/20.html', 99, 1);
INSERT INTO `pes_menu` VALUES (70, '官方社区', 19, 'am-icon-forumbee', 'https://forum.pescms.com/list/20.html', 100, 1);
INSERT INTO `pes_menu` VALUES (71, '应用商店', 19, 'am-icon-cogs', 'Team-Application-index', 95, 0);
COMMIT;

-- ----------------------------
-- Table structure for pes_model
-- ----------------------------
DROP TABLE IF EXISTS `pes_model`;
CREATE TABLE `pes_model` (
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
  `model_name` varchar(128) NOT NULL DEFAULT '',
  `model_title` varchar(128) NOT NULL DEFAULT '',
  `model_status` tinyint(4) NOT NULL DEFAULT '0',
  `model_search` tinyint(11) NOT NULL DEFAULT '0' COMMENT '允许搜索',
  `model_attr` tinyint(1) NOT NULL DEFAULT '0' COMMENT '模型属性 1:前台(含前台) 2:后台',
  PRIMARY KEY (`model_id`),
  UNIQUE KEY `model_name` (`model_name`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='模型列表';

-- ----------------------------
-- Records of pes_model
-- ----------------------------
BEGIN;
INSERT INTO `pes_model` VALUES (1, 'Model', '模型管理', 1, 1, 2);
INSERT INTO `pes_model` VALUES (2, 'Field', '字段管理', 1, 1, 2);
INSERT INTO `pes_model` VALUES (3, 'Menu', '菜单模型', 1, 1, 2);
INSERT INTO `pes_model` VALUES (4, 'Route', '路由规则', 1, 1, 2);
INSERT INTO `pes_model` VALUES (6, 'User_group', '用户组列表', 1, 0, 2);
INSERT INTO `pes_model` VALUES (7, 'User', '用户列表', 1, 0, 2);
INSERT INTO `pes_model` VALUES (8, 'Project', '项目列表', 1, 1, 2);
INSERT INTO `pes_model` VALUES (9, 'Task', '任务列表', 1, 1, 1);
INSERT INTO `pes_model` VALUES (10, 'Department', '部门列表', 1, 1, 2);
INSERT INTO `pes_model` VALUES (13, 'Node', '节点列表', 1, 1, 2);
INSERT INTO `pes_model` VALUES (14, 'Attachment', '附件管理', 1, 1, 2);
INSERT INTO `pes_model` VALUES (15, 'Task_dynamic', '任务动态', 1, 1, 2);
INSERT INTO `pes_model` VALUES (16, 'Task_list', '任务条目', 1, 1, 2);
INSERT INTO `pes_model` VALUES (17, 'task_supplement', '任务补充', 1, 1, 2);
INSERT INTO `pes_model` VALUES (18, 'task_status', '任务状态', 1, 0, 2);
INSERT INTO `pes_model` VALUES (19, 'Notice', '消息通知', 1, 1, 1);
INSERT INTO `pes_model` VALUES (20, 'bulletin', '公告栏', 1, 0, 1);
INSERT INTO `pes_model` VALUES (21, 'priority', '任务优先度', 1, 0, 2);
COMMIT;

-- ----------------------------
-- Table structure for pes_node
-- ----------------------------
DROP TABLE IF EXISTS `pes_node`;
CREATE TABLE `pes_node` (
  `node_id` int(11) NOT NULL AUTO_INCREMENT,
  `node_name` varchar(255) NOT NULL DEFAULT '',
  `node_parent` int(11) NOT NULL DEFAULT '0',
  `node_verify` int(11) NOT NULL DEFAULT '0',
  `node_msg` varchar(255) NOT NULL DEFAULT '',
  `node_method_type` varchar(255) NOT NULL DEFAULT '',
  `node_value` varchar(255) NOT NULL DEFAULT '',
  `node_check_value` varchar(255) NOT NULL DEFAULT '',
  `node_controller` int(11) NOT NULL DEFAULT '0',
  `node_listsort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`node_id`),
  UNIQUE KEY `node_value` (`node_value`,`node_check_value`),
  KEY `node_check_value` (`node_check_value`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='权限节点';

-- ----------------------------
-- Records of pes_node
-- ----------------------------
BEGIN;
INSERT INTO `pes_node` VALUES (1, '新任务', 0, 0, '', 'GET', 'newtask', '', -1, 1);
INSERT INTO `pes_node` VALUES (2, '个人中心', 0, 0, '', 'GET', 'Center', '', -1, 2);
INSERT INTO `pes_node` VALUES (3, '用户中心', 0, 0, '', 'GET', 'Usercenter', '', -1, 3);
INSERT INTO `pes_node` VALUES (4, '内容管理', 0, 0, '', 'GET', 'Contentmanage', '', -1, 4);
INSERT INTO `pes_node` VALUES (5, '高级设置', 0, 0, '', 'GET', 'Advancedsettings', '', -1, 5);
INSERT INTO `pes_node` VALUES (6, '控制器层', 0, 0, '', 'GET', 'Hidecontroller', '', -1, 99);
INSERT INTO `pes_node` VALUES (7, '任务模型', 6, 0, '', 'GET', 'Task', '', 0, 1);
INSERT INTO `pes_node` VALUES (8, '用户模型', 6, 0, '', 'GET', 'User', '', 0, 2);
INSERT INTO `pes_node` VALUES (9, '用户组模型', 6, 0, '', 'GET', 'User_group', '', 0, 3);
INSERT INTO `pes_node` VALUES (10, '部门模型', 6, 0, '', 'GET', 'Department', '', 0, 4);
INSERT INTO `pes_node` VALUES (11, '节点模型', 6, 0, '', 'GET', 'Node', '', 0, 5);
INSERT INTO `pes_node` VALUES (12, '公告模型', 6, 0, '', 'GET', 'Bulletin', '', 0, 6);
INSERT INTO `pes_node` VALUES (13, '任务状态模型', 6, 0, '', 'GET', 'Task_status', '', 0, 7);
INSERT INTO `pes_node` VALUES (14, '附件模型', 6, 0, '', 'GET', 'Attachment', '', 0, 8);
INSERT INTO `pes_node` VALUES (15, '提取报表模型', 6, 0, '', 'GET', 'Report', '', 0, 9);
INSERT INTO `pes_node` VALUES (16, '项目模型', 6, 0, '', 'GET', 'Project', '', 0, 10);
INSERT INTO `pes_node` VALUES (17, '系统设置模型', 6, 0, '', 'GET', 'Setting', '', 0, 11);
INSERT INTO `pes_node` VALUES (18, '菜单管理模型', 6, 0, '', 'GET', 'Menu', '', 0, 12);
INSERT INTO `pes_node` VALUES (19, '路由规则模型', 6, 0, '', 'GET', 'Route', '', 0, 13);
INSERT INTO `pes_node` VALUES (20, '模型管理', 6, 0, '', 'GET', 'Model', '', 0, 14);
INSERT INTO `pes_node` VALUES (21, '字段模型', 6, 0, '', 'GET', 'Field', '', 0, 15);
INSERT INTO `pes_node` VALUES (22, '发布新任务', 1, 1, '', 'GET', 'action', 'TeamGETTaskaction', 7, 1);
INSERT INTO `pes_node` VALUES (23, '我的任务', 2, 1, '', 'GET', 'my', 'TeamGETTaskmy', 7, 1);
INSERT INTO `pes_node` VALUES (24, '任务看板', 2, 1, '', 'GET', 'myCard', 'TeamGETTaskmyCard', 7, 2);
INSERT INTO `pes_node` VALUES (25, '任务列表', 2, 1, '', 'GET', 'index', 'TeamGETTaskindex', 7, 3);
INSERT INTO `pes_node` VALUES (26, '我的报表', 2, 0, '', 'GET', 'my', 'TeamGETReportmy', 15, 4);
INSERT INTO `pes_node` VALUES (27, '审核列表', 2, 0, '', 'GET', 'check', 'TeamGETTaskcheck', 7, 6);
INSERT INTO `pes_node` VALUES (28, '部门指派', 2, 1, '', 'GET', 'department', 'TeamGETTaskdepartment', 7, 5);
INSERT INTO `pes_node` VALUES (29, '用户列表', 3, 1, '', 'GET', 'index', 'TeamGETUserindex', 8, 1);
INSERT INTO `pes_node` VALUES (30, '新增/编辑用户', 3, 1, '', 'GET', 'action', 'TeamGETUseraction', 8, 2);
INSERT INTO `pes_node` VALUES (32, '添加用户', 3, 1, '', 'POST', 'action', 'TeamPOSTUseraction', 8, 3);
INSERT INTO `pes_node` VALUES (33, '更新用户', 3, 1, '', 'PUT', 'action', 'TeamPUTUseraction', 8, 4);
INSERT INTO `pes_node` VALUES (34, '删除用户', 3, 1, '', 'DELETE', 'action', 'TeamDELETEUseraction', 8, 5);
INSERT INTO `pes_node` VALUES (35, '用户组列表', 3, 1, '', 'GET', 'index', 'TeamGETUser_groupindex', 9, 6);
INSERT INTO `pes_node` VALUES (36, '新增/编辑用户组', 3, 1, '', 'GET', 'action', 'TeamGETUser_groupaction', 9, 7);
INSERT INTO `pes_node` VALUES (37, '提交新增用户组', 3, 1, '', 'POST', 'action', 'TeamPOSTUser_groupaction', 9, 8);
INSERT INTO `pes_node` VALUES (38, '提交编辑用户组', 3, 1, '', 'PUT', 'action', 'TeamPUTUser_groupaction', 9, 9);
INSERT INTO `pes_node` VALUES (39, '提交删除用户组', 3, 1, '', 'DELETE', 'action', 'TeamDELETEUser_groupaction', 9, 10);
INSERT INTO `pes_node` VALUES (40, '查看用户组菜单', 3, 1, '', 'GET', 'setMenu', 'TeamGETUser_groupsetMenu', 9, 11);
INSERT INTO `pes_node` VALUES (41, '更新用户组菜单', 3, 1, '', 'PUT', 'setMenu', 'TeamPUTUser_groupsetMenu', 9, 12);
INSERT INTO `pes_node` VALUES (42, '查看用户组权限', 3, 1, '', 'GET', 'setAuth', 'TeamGETUser_groupsetAuth', 9, 13);
INSERT INTO `pes_node` VALUES (43, '更新用户组权限', 3, 1, '', 'PUT', 'setAuth', 'TeamPUTUser_groupsetAuth', 9, 14);
INSERT INTO `pes_node` VALUES (44, '节点列表', 3, 1, '', 'GET', 'index', 'TeamGETNodeindex', 11, 20);
INSERT INTO `pes_node` VALUES (45, '新增/编辑节点', 3, 1, '', 'GET', 'action', 'TeamGETNodeaction', 11, 22);
INSERT INTO `pes_node` VALUES (46, '提交新增节点', 3, 1, '', 'POST', 'action', 'TeamPOSTNodeaction', 11, 23);
INSERT INTO `pes_node` VALUES (47, '提交更新节点', 3, 1, '', 'PUT', 'action', 'TeamPUTNodeaction', 11, 24);
INSERT INTO `pes_node` VALUES (48, '提交删除节点', 3, 1, '', 'DELETE', 'action', 'TeamDELETENodeaction', 11, 25);
INSERT INTO `pes_node` VALUES (49, '部门列表', 3, 1, '', 'GET', 'index', 'TeamGETDepartmentindex', 10, 15);
INSERT INTO `pes_node` VALUES (50, '新增/编辑部门', 3, 1, '', 'GET', 'action', 'TeamGETDepartmentaction', 10, 16);
INSERT INTO `pes_node` VALUES (51, '提交新增部门', 3, 1, '', 'POST', 'action', 'TeamPOSTDepartmentaction', 10, 17);
INSERT INTO `pes_node` VALUES (52, '提交编辑部门', 3, 1, '', 'PUT', 'action', 'TeamPUTDepartmentaction', 10, 18);
INSERT INTO `pes_node` VALUES (53, '提交删除部门', 3, 1, '', 'DELETE', 'action', 'TeamDELETEDepartmentaction', 10, 19);
INSERT INTO `pes_node` VALUES (54, '公告列表', 4, 1, '', 'GET', 'index', 'TeamGETBulletinindex', 12, 1);
INSERT INTO `pes_node` VALUES (55, '新增/编辑公告', 4, 1, '', 'GET', 'action', 'TeamGETBulletinaction', 12, 2);
INSERT INTO `pes_node` VALUES (56, '添加公告', 4, 1, '', 'POST', 'action', 'TeamPOSTBulletinaction', 12, 3);
INSERT INTO `pes_node` VALUES (57, '更新公告', 4, 1, '', 'PUT', 'action', 'TeamPUTBulletinaction', 12, 4);
INSERT INTO `pes_node` VALUES (58, '删除公告', 4, 1, '', 'DELETE', 'action', 'TeamDELETEBulletinaction', 12, 5);
INSERT INTO `pes_node` VALUES (59, '任务状态列表', 4, 1, '', 'GET', 'index', 'TeamGETTask_statusindex', 13, 6);
INSERT INTO `pes_node` VALUES (60, '新增/编辑任务状态', 4, 1, '', 'GET', 'action', 'TeamGETTask_statusaction', 13, 7);
INSERT INTO `pes_node` VALUES (61, '提交新增任务状态', 4, 1, '', 'POST', 'action', 'TeamPOSTTask_statusaction', 13, 8);
INSERT INTO `pes_node` VALUES (62, '提交编辑任务状态', 4, 1, '', 'PUT', 'action', 'TeamPUTTask_statusaction', 13, 9);
INSERT INTO `pes_node` VALUES (63, '提交删除任务状态', 4, 1, '', 'DELETE', 'action', 'TeamDELETETask_statusaction', 13, 10);
INSERT INTO `pes_node` VALUES (69, '附件列表', 4, 1, '', 'GET', 'index', 'TeamGETAttachmentindex', 14, 11);
INSERT INTO `pes_node` VALUES (70, '新增/编辑附件', 4, 1, '', 'GET', 'action', 'TeamGETAttachmentaction', 14, 12);
INSERT INTO `pes_node` VALUES (71, '提交新增附件', 4, 1, '', 'POST', 'action', 'TeamPOSTAttachmentaction', 14, 13);
INSERT INTO `pes_node` VALUES (72, '提交编辑附件', 4, 1, '', 'PUT', 'action', 'TeamPUTAttachmentaction', 14, 14);
INSERT INTO `pes_node` VALUES (73, '提交删除附件', 4, 1, '', 'DELETE', 'action', 'TeamDELETEAttachmentaction', 14, 15);
INSERT INTO `pes_node` VALUES (74, '提取全体报表', 4, 1, '', 'GET', 'allExtract', 'TeamGETReportallExtract', 15, 16);
INSERT INTO `pes_node` VALUES (75, '提取报表', 4, 1, '', 'GET', 'extract', 'TeamGETReportextract', 15, 17);
INSERT INTO `pes_node` VALUES (76, '项目列表', 4, 1, '', 'GET', 'index', 'TeamGETProjectindex', 16, 18);
INSERT INTO `pes_node` VALUES (77, '新增/编辑项目', 4, 1, '', 'GET', 'action', 'TeamGETProjectaction', 16, 19);
INSERT INTO `pes_node` VALUES (78, '提交新增项目', 4, 1, '', 'POST', 'action', 'TeamPOSTProjectaction', 16, 20);
INSERT INTO `pes_node` VALUES (79, '提交编辑项目', 4, 1, '', 'PUT', 'action', 'TeamPUTProjectaction', 16, 21);
INSERT INTO `pes_node` VALUES (80, '提交删除项目', 4, 1, '', 'DELETE', 'action', 'TeamDELETEProjectaction', 16, 22);
INSERT INTO `pes_node` VALUES (81, '系统设置', 5, 1, '', 'GET', 'action', 'TeamGETSettingaction', 17, 1);
INSERT INTO `pes_node` VALUES (82, '更新系统设置', 5, 1, '', 'PUT', 'action', 'TeamPUTSettingaction', 17, 2);
INSERT INTO `pes_node` VALUES (83, '系统更新', 5, 1, '', 'GET', 'upgrade', 'TeamGETSettingupgrade', 17, 3);
INSERT INTO `pes_node` VALUES (84, '系统手动更新', 5, 1, '', 'PUT', 'mtUpgrade', 'TeamPUTSettingmtUpgrade', 17, 4);
INSERT INTO `pes_node` VALUES (85, '菜单列表', 5, 1, '', 'GET', 'index', 'TeamGETMenuindex', 18, 5);
INSERT INTO `pes_node` VALUES (86, '新增/编辑菜单', 5, 1, '', 'GET', 'action', 'TeamGETMenuaction', 18, 6);
INSERT INTO `pes_node` VALUES (87, '提交新增菜单', 5, 1, '', 'POST', 'action', 'TeamPOSTMenuaction', 18, 7);
INSERT INTO `pes_node` VALUES (88, '提交编辑菜单', 5, 1, '', 'PUT', 'action', 'TeamPUTMenuaction', 18, 8);
INSERT INTO `pes_node` VALUES (89, '提交删除菜单', 5, 1, '', 'DELETE', 'action', 'TeamDELETEMenuaction', 18, 9);
INSERT INTO `pes_node` VALUES (90, '隐藏操作', 0, 0, '', 'GET', 'Hideoperating', '', -1, 98);
INSERT INTO `pes_node` VALUES (91, '模型列表', 90, 1, '', 'GET', 'index', 'TeamGETModelindex', 20, 1);
INSERT INTO `pes_node` VALUES (92, '新增/编辑模型', 90, 1, '', 'GET', 'action', 'TeamGETModelaction', 20, 2);
INSERT INTO `pes_node` VALUES (93, '新增模型', 90, 1, '', 'POST', 'action', 'TeamPOSTModelaction', 20, 3);
INSERT INTO `pes_node` VALUES (94, '更新模型', 90, 1, '', 'PUT', 'action', 'TeamPUTModelaction', 20, 4);
INSERT INTO `pes_node` VALUES (95, '删除模型', 90, 1, '', 'DELETE', 'action', 'TeamDELETEModelaction', 20, 5);
INSERT INTO `pes_node` VALUES (96, '字段列表', 90, 1, '', 'GET', 'index', 'TeamGETFieldindex', 21, 6);
INSERT INTO `pes_node` VALUES (97, '新增/编辑字段', 90, 1, '', 'GET', 'action', 'TeamGETFieldaction', 21, 7);
INSERT INTO `pes_node` VALUES (98, '新增字段', 90, 1, '', 'POST', 'action', 'TeamPOSTFieldaction', 21, 8);
INSERT INTO `pes_node` VALUES (99, '更新字段', 90, 1, '', 'PUT', 'action', 'TeamPUTFieldaction', 21, 9);
INSERT INTO `pes_node` VALUES (100, '删除字段', 90, 1, '', 'DELETE', 'action', 'TeamDELETEFieldaction', 21, 10);
INSERT INTO `pes_node` VALUES (101, '任务优先度模型', 6, 0, '', 'GET', 'Priority', '', 0, 16);
INSERT INTO `pes_node` VALUES (102, '任务优先度列表', 4, 1, '', 'GET', 'index', 'TeamGETPriorityindex', 101, 23);
INSERT INTO `pes_node` VALUES (103, '新增/编辑任务优先度', 4, 1, '', 'GET', 'action', 'TeamGETPriorityaction', 101, 24);
INSERT INTO `pes_node` VALUES (104, '新增任务优先度', 4, 1, '', 'POST', 'action', 'TeamPOSTPriorityaction', 101, 25);
INSERT INTO `pes_node` VALUES (105, '更新任务优先度', 4, 1, '', 'PUT', 'action', 'TeamPUTPriorityaction', 101, 26);
INSERT INTO `pes_node` VALUES (106, '删除任务优先度', 4, 1, '', 'DELETE', 'action', 'TeamDELETEPriorityaction', 101, 27);
INSERT INTO `pes_node` VALUES (107, '复制用户组', 3, 1, '', 'POST', 'copy', 'TeamPOSTUser_groupcopy', 9, 9);
INSERT INTO `pes_node` VALUES (108, '删除任务', 1, 1, '', 'DELETE', 'action', 'TeamDELETETaskaction', 7, 2);
COMMIT;

-- ----------------------------
-- Table structure for pes_node_group
-- ----------------------------
DROP TABLE IF EXISTS `pes_node_group`;
CREATE TABLE `pes_node_group` (
  `node_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_group_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户组ID',
  `node_id` int(11) NOT NULL DEFAULT '0' COMMENT '节点ID',
  PRIMARY KEY (`node_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8 COMMENT='用户组权限节点';

-- ----------------------------
-- Records of pes_node_group
-- ----------------------------
BEGIN;
INSERT INTO `pes_node_group` VALUES (1, 2, 1);
INSERT INTO `pes_node_group` VALUES (2, 2, 22);
INSERT INTO `pes_node_group` VALUES (3, 2, 2);
INSERT INTO `pes_node_group` VALUES (4, 2, 23);
INSERT INTO `pes_node_group` VALUES (5, 2, 24);
INSERT INTO `pes_node_group` VALUES (6, 2, 25);
INSERT INTO `pes_node_group` VALUES (7, 2, 26);
INSERT INTO `pes_node_group` VALUES (8, 3, 1);
INSERT INTO `pes_node_group` VALUES (9, 3, 22);
INSERT INTO `pes_node_group` VALUES (10, 3, 2);
INSERT INTO `pes_node_group` VALUES (11, 3, 23);
INSERT INTO `pes_node_group` VALUES (12, 3, 24);
INSERT INTO `pes_node_group` VALUES (13, 3, 25);
INSERT INTO `pes_node_group` VALUES (14, 3, 26);
INSERT INTO `pes_node_group` VALUES (15, 3, 28);
INSERT INTO `pes_node_group` VALUES (16, 3, 27);
INSERT INTO `pes_node_group` VALUES (17, 3, 4);
INSERT INTO `pes_node_group` VALUES (18, 3, 75);
INSERT INTO `pes_node_group` VALUES (86, 1, 1);
INSERT INTO `pes_node_group` VALUES (87, 1, 22);
INSERT INTO `pes_node_group` VALUES (88, 1, 2);
INSERT INTO `pes_node_group` VALUES (89, 1, 23);
INSERT INTO `pes_node_group` VALUES (90, 1, 24);
INSERT INTO `pes_node_group` VALUES (91, 1, 25);
INSERT INTO `pes_node_group` VALUES (92, 1, 26);
INSERT INTO `pes_node_group` VALUES (93, 1, 28);
INSERT INTO `pes_node_group` VALUES (94, 1, 27);
INSERT INTO `pes_node_group` VALUES (95, 1, 3);
INSERT INTO `pes_node_group` VALUES (96, 1, 29);
INSERT INTO `pes_node_group` VALUES (97, 1, 30);
INSERT INTO `pes_node_group` VALUES (98, 1, 32);
INSERT INTO `pes_node_group` VALUES (99, 1, 33);
INSERT INTO `pes_node_group` VALUES (100, 1, 34);
INSERT INTO `pes_node_group` VALUES (101, 1, 35);
INSERT INTO `pes_node_group` VALUES (102, 1, 36);
INSERT INTO `pes_node_group` VALUES (103, 1, 37);
INSERT INTO `pes_node_group` VALUES (104, 1, 38);
INSERT INTO `pes_node_group` VALUES (105, 1, 39);
INSERT INTO `pes_node_group` VALUES (106, 1, 40);
INSERT INTO `pes_node_group` VALUES (107, 1, 41);
INSERT INTO `pes_node_group` VALUES (108, 1, 42);
INSERT INTO `pes_node_group` VALUES (109, 1, 43);
INSERT INTO `pes_node_group` VALUES (110, 1, 49);
INSERT INTO `pes_node_group` VALUES (111, 1, 50);
INSERT INTO `pes_node_group` VALUES (112, 1, 51);
INSERT INTO `pes_node_group` VALUES (113, 1, 52);
INSERT INTO `pes_node_group` VALUES (114, 1, 53);
INSERT INTO `pes_node_group` VALUES (115, 1, 44);
INSERT INTO `pes_node_group` VALUES (116, 1, 45);
INSERT INTO `pes_node_group` VALUES (117, 1, 46);
INSERT INTO `pes_node_group` VALUES (118, 1, 47);
INSERT INTO `pes_node_group` VALUES (119, 1, 48);
INSERT INTO `pes_node_group` VALUES (120, 1, 4);
INSERT INTO `pes_node_group` VALUES (121, 1, 54);
INSERT INTO `pes_node_group` VALUES (122, 1, 55);
INSERT INTO `pes_node_group` VALUES (123, 1, 56);
INSERT INTO `pes_node_group` VALUES (124, 1, 57);
INSERT INTO `pes_node_group` VALUES (125, 1, 58);
INSERT INTO `pes_node_group` VALUES (126, 1, 59);
INSERT INTO `pes_node_group` VALUES (127, 1, 60);
INSERT INTO `pes_node_group` VALUES (128, 1, 61);
INSERT INTO `pes_node_group` VALUES (129, 1, 62);
INSERT INTO `pes_node_group` VALUES (130, 1, 63);
INSERT INTO `pes_node_group` VALUES (131, 1, 69);
INSERT INTO `pes_node_group` VALUES (132, 1, 70);
INSERT INTO `pes_node_group` VALUES (133, 1, 71);
INSERT INTO `pes_node_group` VALUES (134, 1, 72);
INSERT INTO `pes_node_group` VALUES (135, 1, 73);
INSERT INTO `pes_node_group` VALUES (136, 1, 74);
INSERT INTO `pes_node_group` VALUES (137, 1, 75);
INSERT INTO `pes_node_group` VALUES (138, 1, 76);
INSERT INTO `pes_node_group` VALUES (139, 1, 77);
INSERT INTO `pes_node_group` VALUES (140, 1, 78);
INSERT INTO `pes_node_group` VALUES (141, 1, 79);
INSERT INTO `pes_node_group` VALUES (142, 1, 80);
INSERT INTO `pes_node_group` VALUES (143, 1, 102);
INSERT INTO `pes_node_group` VALUES (144, 1, 103);
INSERT INTO `pes_node_group` VALUES (145, 1, 104);
INSERT INTO `pes_node_group` VALUES (146, 1, 105);
INSERT INTO `pes_node_group` VALUES (147, 1, 106);
INSERT INTO `pes_node_group` VALUES (148, 1, 5);
INSERT INTO `pes_node_group` VALUES (149, 1, 81);
INSERT INTO `pes_node_group` VALUES (150, 1, 82);
INSERT INTO `pes_node_group` VALUES (151, 1, 83);
INSERT INTO `pes_node_group` VALUES (152, 1, 84);
INSERT INTO `pes_node_group` VALUES (153, 1, 85);
INSERT INTO `pes_node_group` VALUES (154, 1, 86);
INSERT INTO `pes_node_group` VALUES (155, 1, 87);
INSERT INTO `pes_node_group` VALUES (156, 1, 88);
INSERT INTO `pes_node_group` VALUES (157, 1, 89);
COMMIT;

-- ----------------------------
-- Table structure for pes_notice
-- ----------------------------
DROP TABLE IF EXISTS `pes_notice`;
CREATE TABLE `pes_notice` (
  `notice_id` int(11) NOT NULL AUTO_INCREMENT,
  `notice_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '接收的用户ID',
  `notice_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1.新任务 2.新审核任务 3.新待审核任务 4.新待指派任务 5.任务内容修改/补充',
  `notice_read` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已读：0 未读 1 已读',
  `notice_title` varchar(255) NOT NULL DEFAULT '' COMMENT '消息标题',
  `notice_content` text NOT NULL COMMENT '消息内容',
  `notice_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`notice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='系统信息消息';

-- ----------------------------
-- Records of pes_notice
-- ----------------------------
BEGIN;
INSERT INTO `pes_notice` VALUES (1, 1, 2, 1, '<a href=\"/?g=Team&m=User&a=view&id=1\">admin</a> 在任务 <a href=\"/?g=Team&m=Task&a=view&id=1\">222</a> 中赋予您审核的权限', '<p>任务计划开始时间:2021-10-27 22:00</p><p>任务计划结束时间:2021-10-29 19:00</p>&lt;p&gt;222&lt;/p&gt;', 1635090891);
INSERT INTO `pes_notice` VALUES (2, 1, 1, 1, '<a href=\"/?g=Team&m=User&a=view&id=1\">admin</a> 在任务 <a href=\"/?g=Team&m=Task&a=view&id=1\">222</a> 中指派给您执行任务的需求', '<p>任务计划开始时间:2021-10-27 22:00</p><p>任务计划结束时间:2021-10-29 19:00</p>&lt;p&gt;222&lt;/p&gt;', 1635090891);
INSERT INTO `pes_notice` VALUES (3, 1, 2, 1, '<a href=\"/?g=Team&m=User&a=view&id=1\">admin</a> 在任务 <a href=\"/?g=Team&m=Task&a=view&id=2\">本周安排</a> 中赋予您审核的权限', '<p>任务计划开始时间:2021-10-26 02:00</p><p>任务计划结束时间:2021-10-28 14:00</p>&lt;p&gt;学习PHP&lt;/p&gt;&lt;p&gt;学习数据库&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;', 1635091531);
INSERT INTO `pes_notice` VALUES (4, 2, 2, 1, '<a href=\"/?g=Team&m=User&a=view&id=1\">admin</a> 在任务 <a href=\"/?g=Team&m=Task&a=view&id=2\">本周安排</a> 中赋予您审核的权限', '<p>任务计划开始时间:2021-10-26 02:00</p><p>任务计划结束时间:2021-10-28 14:00</p>&lt;p&gt;学习PHP&lt;/p&gt;&lt;p&gt;学习数据库&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;', 1635091531);
INSERT INTO `pes_notice` VALUES (5, 2, 1, 1, '<a href=\"/?g=Team&m=User&a=view&id=1\">admin</a> 在任务 <a href=\"/?g=Team&m=Task&a=view&id=2\">本周安排</a> 中指派给您执行任务的需求', '<p>任务计划开始时间:2021-10-26 02:00</p><p>任务计划结束时间:2021-10-28 14:00</p>&lt;p&gt;学习PHP&lt;/p&gt;&lt;p&gt;学习数据库&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;', 1635091531);
INSERT INTO `pes_notice` VALUES (6, 1, 2, 1, '<a href=\"/?g=Team&m=User&a=view&id=1\">admin</a> 在任务 <a href=\"/?g=Team&m=Task&a=view&id=3\">再学培训资料（大并发面试准备）</a> 中赋予您审核的权限', '<p>任务计划开始时间:2021-10-26 10:00</p><p>任务计划结束时间:2021-10-31 22:00</p>', 1635216778);
INSERT INTO `pes_notice` VALUES (7, 2, 1, 1, '<a href=\"/?g=Team&m=User&a=view&id=1\">admin</a> 在任务 <a href=\"/?g=Team&m=Task&a=view&id=3\">再学培训资料（大并发面试准备）</a> 中指派给您执行任务的需求', '<p>任务计划开始时间:2021-10-26 10:00</p><p>任务计划结束时间:2021-10-31 22:00</p>', 1635216778);
INSERT INTO `pes_notice` VALUES (8, 1, 5, 1, '<a href=\"/?g=Team&m=User&a=view&id=1\">admin</a> 在任务 <a href=\"/?g=Team&m=Task&a=view&id=1\">wwww</a> 中对内容进行修改和补充说明，请您留意该变动', '&lt;p&gt;222&lt;/p&gt;', 1635678742);
INSERT INTO `pes_notice` VALUES (9, 1, 3, 1, '<a href=\"/?g=Team&m=User&a=view&id=1\">admin</a> 在任务 <a href=\"/?g=Team&m=Task&a=view&id=1\">wwww</a> 中提交了审核，请您对该任务进行验证审核', '<p>任务计划开始时间:2021-10-27 22:00</p><p>任务计划结束时间:2021-10-29 19:00</p>&lt;p&gt;222&lt;/p&gt;', 1635678814);
COMMIT;

-- ----------------------------
-- Table structure for pes_option
-- ----------------------------
DROP TABLE IF EXISTS `pes_option`;
CREATE TABLE `pes_option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `option_name` varchar(128) NOT NULL DEFAULT '',
  `name` varchar(128) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  `option_range` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COMMENT='系统选项';

-- ----------------------------
-- Records of pes_option
-- ----------------------------
BEGIN;
INSERT INTO `pes_option` VALUES (13, 'version', '系统版本', '2.3.3', 'system');
INSERT INTO `pes_option` VALUES (14, 'upload_img', '图片格式', '[\".jpg\",\".jpge\",\".bmp\",\".gif\",\".png\"]', 'system');
INSERT INTO `pes_option` VALUES (15, 'upload_file', '文件格式', '[\".zip\",\".rar\",\".7z\",\".doc\",\".docx\",\".pdf\",\".xls\",\".xlsx\",\".ppt\",\".pptx\",\".txt\"]', 'system');
INSERT INTO `pes_option` VALUES (17, 'mail', '邮件服务信息', '{\"account\":\"\",\"passwd\":\"\",\"address\":\"\",\"port\":\"\"}', '');
INSERT INTO `pes_option` VALUES (19, 'signup', '帐号注册', '1', 'system');
INSERT INTO `pes_option` VALUES (22, 'notice_way', '消息推送方式', '2', 'system');
COMMIT;

-- ----------------------------
-- Table structure for pes_priority
-- ----------------------------
DROP TABLE IF EXISTS `pes_priority`;
CREATE TABLE `pes_priority` (
  `priority_id` int(11) NOT NULL AUTO_INCREMENT,
  `priority_listsort` int(11) NOT NULL DEFAULT '0',
  `priority_name` varchar(255) NOT NULL DEFAULT '',
  `priority_color` varchar(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`priority_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pes_priority
-- ----------------------------
BEGIN;
INSERT INTO `pes_priority` VALUES (1, 1, 'P1重要且紧急', '#999999');
INSERT INTO `pes_priority` VALUES (2, 2, 'P2重要且不紧急', '#3bb4f2');
INSERT INTO `pes_priority` VALUES (4, 3, 'P3不重要且紧急', '#f37b1d');
INSERT INTO `pes_priority` VALUES (5, 4, 'P4不重要且不紧急', '#dd514c');
COMMIT;

-- ----------------------------
-- Table structure for pes_project
-- ----------------------------
DROP TABLE IF EXISTS `pes_project`;
CREATE TABLE `pes_project` (
  `project_id` int(11) NOT NULL AUTO_INCREMENT,
  `project_listsort` int(11) NOT NULL DEFAULT '0',
  `project_title` varchar(255) NOT NULL DEFAULT '',
  `project_content` text NOT NULL,
  PRIMARY KEY (`project_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='项目列表';

-- ----------------------------
-- Records of pes_project
-- ----------------------------
BEGIN;
INSERT INTO `pes_project` VALUES (1, 1, '不指定任务', '&lt;p&gt;一些不知名的任务都会存放于本项目之中。&lt;/p&gt;');
INSERT INTO `pes_project` VALUES (2, 0, '坤时本周工作安排', '&lt;p&gt;日常工作安排&lt;/p&gt;');
INSERT INTO `pes_project` VALUES (3, 0, '工作室第四季度任务安排', '');
COMMIT;

-- ----------------------------
-- Table structure for pes_report
-- ----------------------------
DROP TABLE IF EXISTS `pes_report`;
CREATE TABLE `pes_report` (
  `report_id` int(11) NOT NULL AUTO_INCREMENT,
  `report_date` int(11) NOT NULL DEFAULT '0' COMMENT '报表日期',
  `user_id` int(255) NOT NULL DEFAULT '0',
  `department_id` int(11) NOT NULL DEFAULT '0' COMMENT '部门ID',
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户报表';

-- ----------------------------
-- Records of pes_report
-- ----------------------------
BEGIN;
INSERT INTO `pes_report` VALUES (1, 1635609600, 2, 1);
INSERT INTO `pes_report` VALUES (2, 1635609600, 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for pes_report_content
-- ----------------------------
DROP TABLE IF EXISTS `pes_report_content`;
CREATE TABLE `pes_report_content` (
  `content_id` int(11) NOT NULL AUTO_INCREMENT,
  `report_id` int(11) NOT NULL DEFAULT '0',
  `report_content` text NOT NULL,
  PRIMARY KEY (`content_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='报表内容';

-- ----------------------------
-- Records of pes_report_content
-- ----------------------------
BEGIN;
INSERT INTO `pes_report_content` VALUES (1, 1, 'wnsto将任务<a href=\"/?g=Team&m=Task&a=view&id=2\">《本周安排》</a>状态变更为：进行。');
INSERT INTO `pes_report_content` VALUES (2, 1, 'wnsto将任务<a href=\"/?g=Team&m=Task&a=view&id=3\">《再学培训资料（大并发面试准备）》</a>状态变更为：进行。');
INSERT INTO `pes_report_content` VALUES (3, 2, 'admin将任务<a href=\"/?g=Team&m=Task&a=view&id=1\">《wwww》</a>状态变更为：进行。');
INSERT INTO `pes_report_content` VALUES (4, 2, 'admin将任务<a href=\"/?g=Team&m=Task&a=view&id=1\">《wwww》</a>状态变更为：审核。');
INSERT INTO `pes_report_content` VALUES (5, 2, 'admin将任务<a href=\"/?g=Team&m=Task&a=view&id=1\">《wwww》</a>状态变更为：完成。');
COMMIT;

-- ----------------------------
-- Table structure for pes_route
-- ----------------------------
DROP TABLE IF EXISTS `pes_route`;
CREATE TABLE `pes_route` (
  `route_id` int(11) NOT NULL AUTO_INCREMENT,
  `route_controller` varchar(255) NOT NULL DEFAULT '',
  `route_param` varchar(255) NOT NULL DEFAULT '',
  `route_rule` varchar(255) NOT NULL DEFAULT '',
  `route_title` varchar(255) NOT NULL DEFAULT '',
  `route_hash` varchar(255) NOT NULL DEFAULT '',
  `route_listsort` int(11) NOT NULL DEFAULT '0',
  `route_status` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`route_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='路由表';

-- ----------------------------
-- Table structure for pes_send
-- ----------------------------
DROP TABLE IF EXISTS `pes_send`;
CREATE TABLE `pes_send` (
  `send_id` int(11) NOT NULL AUTO_INCREMENT,
  `send_account` varchar(255) NOT NULL DEFAULT '',
  `send_title` varchar(255) NOT NULL DEFAULT '' COMMENT '待发送标题',
  `send_content` text NOT NULL COMMENT '待发送的内容',
  `send_time` int(11) NOT NULL DEFAULT '0' COMMENT '发送时间',
  `send_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1:邮箱 2:手机 ..',
  PRIMARY KEY (`send_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='待发送列表';

-- ----------------------------
-- Table structure for pes_task
-- ----------------------------
DROP TABLE IF EXISTS `pes_task`;
CREATE TABLE `pes_task` (
  `task_id` int(11) NOT NULL AUTO_INCREMENT,
  `task_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0: 待办 1:执行中 2:审核 3:完成 10:关闭',
  `task_title` varchar(255) NOT NULL DEFAULT '' COMMENT '任务标题',
  `task_create_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `task_multiplayer` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:单人任务 1：多人任务',
  `task_content` text NOT NULL COMMENT '任务文本内容',
  `task_priority` tinyint(1) NOT NULL DEFAULT '0' COMMENT '任务优先度',
  `task_project_id` int(11) NOT NULL DEFAULT '0' COMMENT '对应项目的ID',
  `task_read_permission` tinyint(1) NOT NULL DEFAULT '0' COMMENT '阅读权限',
  `task_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:正常 1:任务被删除。被删除是由于用户被删除了',
  `task_mail` tinyint(1) NOT NULL DEFAULT '0' COMMENT '本任务全程是否发送邮件 0:不 1:发',
  `task_submit_time` int(11) NOT NULL DEFAULT '0' COMMENT '任务提交时间',
  `task_complete_time` int(11) NOT NULL DEFAULT '0' COMMENT '完成时间',
  `task_start_time` int(11) NOT NULL DEFAULT '0' COMMENT '任务计划开始时间',
  `task_end_time` int(11) NOT NULL DEFAULT '0' COMMENT '任务计划结束时间',
  `task_repeat` varchar(8) NOT NULL DEFAULT '' COMMENT '任务重复天数',
  PRIMARY KEY (`task_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='任务列表';

-- ----------------------------
-- Records of pes_task
-- ----------------------------
BEGIN;
INSERT INTO `pes_task` VALUES (2, 1, '本周安排', 1, 0, '&lt;p&gt;学习PHP&lt;/p&gt;&lt;p&gt;学习数据库&lt;/p&gt;&lt;p&gt;&lt;br/&gt;&lt;/p&gt;', 1, 3, 0, 0, 0, 1635091500, 0, 1635184800, 1635400800, '');
INSERT INTO `pes_task` VALUES (3, 1, '再学培训资料（大并发面试准备）', 1, 0, '', 1, 3, 0, 0, 0, 1635216720, 0, 1635213600, 1635688800, '');
COMMIT;

-- ----------------------------
-- Table structure for pes_task_dynamic
-- ----------------------------
DROP TABLE IF EXISTS `pes_task_dynamic`;
CREATE TABLE `pes_task_dynamic` (
  `task_dynamic_id` int(11) NOT NULL AUTO_INCREMENT,
  `task_dynamic_createtime` int(11) NOT NULL DEFAULT '0',
  `task_dynamic_task_id` varchar(255) NOT NULL DEFAULT '',
  `task_dynamic_user_id` varchar(255) NOT NULL DEFAULT '',
  `task_dynamic_content` text NOT NULL,
  PRIMARY KEY (`task_dynamic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='任务动态';

-- ----------------------------
-- Table structure for pes_task_list
-- ----------------------------
DROP TABLE IF EXISTS `pes_task_list`;
CREATE TABLE `pes_task_list` (
  `task_list_id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL DEFAULT '0' COMMENT '任务id',
  `task_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '执行条目的人',
  `task_list_content` text NOT NULL COMMENT '条目内容',
  `task_list_time` int(11) NOT NULL DEFAULT '0' COMMENT '条目完成时间',
  PRIMARY KEY (`task_list_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='任务明细条目';

-- ----------------------------
-- Records of pes_task_list
-- ----------------------------
BEGIN;
INSERT INTO `pes_task_list` VALUES (1, 1, 0, '222', 0);
INSERT INTO `pes_task_list` VALUES (3, 2, 0, '学习数据库', 0);
INSERT INTO `pes_task_list` VALUES (4, 3, 2, '1 理解何为大型网站，指标。', 1635696562);
INSERT INTO `pes_task_list` VALUES (5, 3, 0, '2 网站优化技术之页面静态化', 0);
INSERT INTO `pes_task_list` VALUES (6, 3, 0, '3 网站优化技术之页面静态化', 0);
INSERT INTO `pes_task_list` VALUES (7, 3, 0, '4 面试汇总题目复习', 0);
INSERT INTO `pes_task_list` VALUES (8, 3, 2, '5 案例#在两台服务器如何互相做nginx负载均衡。', 1635331516);
INSERT INTO `pes_task_list` VALUES (10, 3, 0, '5 案例#在两台服务器如何互相做nginx负载均衡（参考： https://www.cnblogs.com/yehuisir/p/12381560.html）。', 0);
INSERT INTO `pes_task_list` VALUES (11, 3, 0, '7 制作智能巡检项目环境docker', 0);
INSERT INTO `pes_task_list` VALUES (12, 1, 0, '2222', 0);
INSERT INTO `pes_task_list` VALUES (13, 3, 2, '8 redis的I/O多路复用学习', 1635696555);
COMMIT;

-- ----------------------------
-- Table structure for pes_task_status
-- ----------------------------
DROP TABLE IF EXISTS `pes_task_status`;
CREATE TABLE `pes_task_status` (
  `task_status_id` int(11) NOT NULL AUTO_INCREMENT,
  `task_status_name` varchar(255) NOT NULL DEFAULT '',
  `task_status_icon` varchar(32) NOT NULL DEFAULT '',
  `task_status_color` varchar(8) NOT NULL DEFAULT '',
  `task_status_type` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`task_status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pes_task_status
-- ----------------------------
BEGIN;
INSERT INTO `pes_task_status` VALUES (1, '待办', 'am-icon-eject', '#000000', 0);
INSERT INTO `pes_task_status` VALUES (2, '进行', 'am-icon-play', '#666666', 1);
INSERT INTO `pes_task_status` VALUES (3, '审核', 'am-icon-compress', '#3bb4f2', 2);
INSERT INTO `pes_task_status` VALUES (4, '完成', 'am-icon-check', '#5eb95e', 3);
INSERT INTO `pes_task_status` VALUES (5, '关闭', 'am-icon-close', '#dd514c', 10);
COMMIT;

-- ----------------------------
-- Table structure for pes_task_supplement
-- ----------------------------
DROP TABLE IF EXISTS `pes_task_supplement`;
CREATE TABLE `pes_task_supplement` (
  `task_supplement_id` int(11) NOT NULL AUTO_INCREMENT,
  `task_supplement_task_id` int(11) NOT NULL DEFAULT '0' COMMENT '任务ID',
  `task_supplement_content` text NOT NULL COMMENT '补充说明',
  `task_supplement_createtime` int(11) NOT NULL DEFAULT '0' COMMENT '补充时间',
  `task_supplement_user_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`task_supplement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='任务补充说明';

-- ----------------------------
-- Table structure for pes_task_user
-- ----------------------------
DROP TABLE IF EXISTS `pes_task_user`;
CREATE TABLE `pes_task_user` (
  `task_user_id` int(11) NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL DEFAULT '0' COMMENT '任务ID',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `task_user_type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '任务类型 1:审核者 2:执行者 3:部门',
  PRIMARY KEY (`task_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='任务审核人/执行人列表';

-- ----------------------------
-- Records of pes_task_user
-- ----------------------------
BEGIN;
INSERT INTO `pes_task_user` VALUES (3, 2, 1, 1);
INSERT INTO `pes_task_user` VALUES (4, 2, 2, 1);
INSERT INTO `pes_task_user` VALUES (5, 2, 2, 2);
INSERT INTO `pes_task_user` VALUES (6, 3, 1, 1);
INSERT INTO `pes_task_user` VALUES (7, 3, 2, 2);
INSERT INTO `pes_task_user` VALUES (8, 1, 1, 1);
INSERT INTO `pes_task_user` VALUES (9, 1, 1, 2);
COMMIT;

-- ----------------------------
-- Table structure for pes_user
-- ----------------------------
DROP TABLE IF EXISTS `pes_user`;
CREATE TABLE `pes_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_account` varchar(255) NOT NULL DEFAULT '',
  `user_password` varchar(255) NOT NULL DEFAULT '',
  `user_mail` varchar(255) NOT NULL DEFAULT '',
  `user_name` varchar(255) NOT NULL DEFAULT '',
  `user_group_id` int(11) NOT NULL DEFAULT '0',
  `user_status` tinyint(4) NOT NULL DEFAULT '0',
  `user_createtime` int(11) NOT NULL DEFAULT '0',
  `user_last_login` int(11) NOT NULL DEFAULT '0',
  `user_department_id` varchar(255) NOT NULL DEFAULT '',
  `user_head` text NOT NULL COMMENT '用户头像',
  `user_ey` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '用户的ey值',
  `user_phone` varchar(255) NOT NULL DEFAULT '',
  `user_home` varchar(255) NOT NULL DEFAULT '',
  `user_openid` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_account` (`user_account`),
  UNIQUE KEY `user_mail` (`user_mail`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pes_user
-- ----------------------------
BEGIN;
INSERT INTO `pes_user` VALUES (1, 'admin', '$6$782cc7280d$lIgO/Rk8V13GTvN1Q8ycBVF2zi1qhGc7x/ElmNixnEEpXBpsoR.IWDEbkld3pWd7o9Fgd.zXsTCiJ7oKUb0bQ1', 'admin@g.com', 'admin', 1, 1, 1635082519, 0, '1', '', 3, '', '', '');
INSERT INTO `pes_user` VALUES (2, 'wnsto', '$6$782cc7280d$K8E1i7H4qc76nxlUC6Ybh6ZKOa1q4wmROfbu6mswfizoNIKLBkcBEznUk9trn1hd0NJKDaYn0s8lIH6N8lpI6/', 'wnsto@17logs.com', 'wnsto', 2, 1, 0, 0, '1', '', 2, '', '', '');
INSERT INTO `pes_user` VALUES (3, 'tanjian', '$6$782cc7280d$AVbQcQqL2by990BEEfpbf2IM3lvSh2v98ZmA/SzYdf1PFStImoI9MvR/LwrkX3WPG9Nxj9zimOra0kpMsbY.20', 'tanjian@17logs.com', '小谭', 2, 1, 0, 0, '1', '', 0, '', '', '');
COMMIT;

-- ----------------------------
-- Table structure for pes_user_group
-- ----------------------------
DROP TABLE IF EXISTS `pes_user_group`;
CREATE TABLE `pes_user_group` (
  `user_group_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_group_status` tinyint(4) NOT NULL DEFAULT '0',
  `user_group_createtime` int(11) NOT NULL DEFAULT '0',
  `user_group_name` varchar(255) NOT NULL DEFAULT '',
  `user_group_menu` text NOT NULL COMMENT '用户组菜单列表',
  PRIMARY KEY (`user_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pes_user_group
-- ----------------------------
BEGIN;
INSERT INTO `pes_user_group` VALUES (1, 1, 1417273380, '管理员', '51,41,66,42,59,39,46,60,61,67,62,64,55,16,18,40,49,9,63,58,65,50,48,19,56,8,54,20,68,69,70');
INSERT INTO `pes_user_group` VALUES (2, 1, 1417273440, '普通会员', '51,41,66,42,59,39,46,67,62,64');
INSERT INTO `pes_user_group` VALUES (3, 1, 1417273440, '部门责任人', '51,41,66,42,59,39,46,60,61,67,62,64,9,65,48');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
